/*
Navicat SQL Server Data Transfer

Source Server         : 本机SQLServer
Source Server Version : 140000
Source Host           : localhost:1433
Source Database       : BoKeYuanDb
Source Schema         : dbo

Target Server Type    : SQL Server
Target Server Version : 140000
File Encoding         : 65001

Date: 2018-11-08 15:24:46
*/


-- ----------------------------
-- Table structure for myRecord
-- ----------------------------
DROP TABLE [dbo].[myRecord]
GO
CREATE TABLE [dbo].[myRecord] (
[guid] varchar(50) NOT NULL ,
[recordTime] datetime NULL ,
[score] int NULL ,
[ranking] int NULL 
)


GO

-- ----------------------------
-- Records of myRecord
-- ----------------------------
INSERT INTO [dbo].[myRecord] ([guid], [recordTime], [score], [ranking]) VALUES (N'1', N'2018-10-19 00:00:00.000', N'15928', N'28870')
GO
GO
INSERT INTO [dbo].[myRecord] ([guid], [recordTime], [score], [ranking]) VALUES (N'10', N'2018-11-06 10:14:00.000', N'16371', N'28728')
GO
GO
INSERT INTO [dbo].[myRecord] ([guid], [recordTime], [score], [ranking]) VALUES (N'2', N'2018-10-21 00:00:00.000', N'15958', N'28878')
GO
GO
INSERT INTO [dbo].[myRecord] ([guid], [recordTime], [score], [ranking]) VALUES (N'3', N'2018-10-23 00:00:00.000', N'16051', N'28788')
GO
GO
INSERT INTO [dbo].[myRecord] ([guid], [recordTime], [score], [ranking]) VALUES (N'4', N'2018-10-25 00:00:00.000', N'16067', N'28799')
GO
GO
INSERT INTO [dbo].[myRecord] ([guid], [recordTime], [score], [ranking]) VALUES (N'5', N'2018-10-29 00:00:00.000', N'16211', N'28721')
GO
GO
INSERT INTO [dbo].[myRecord] ([guid], [recordTime], [score], [ranking]) VALUES (N'6', N'2018-10-30 00:00:00.000', N'16222', N'28740')
GO
GO
INSERT INTO [dbo].[myRecord] ([guid], [recordTime], [score], [ranking]) VALUES (N'7', N'2018-10-31 09:14:00.000', N'16297', N'28673')
GO
GO
INSERT INTO [dbo].[myRecord] ([guid], [recordTime], [score], [ranking]) VALUES (N'8', N'2018-11-01 09:49:00.000', N'16315', N'28686')
GO
GO
INSERT INTO [dbo].[myRecord] ([guid], [recordTime], [score], [ranking]) VALUES (N'9', N'2018-11-05 09:25:00.000', N'16362', N'28723')
GO
GO

-- ----------------------------
-- Table structure for Statistics
-- ----------------------------
DROP TABLE [dbo].[Statistics]
GO
CREATE TABLE [dbo].[Statistics] (
[guid] varchar(50) NOT NULL ,
[recordTime] datetime NOT NULL ,
[blog] int NULL ,
[jotting] int NULL ,
[article] int NULL ,
[comment] int NULL 
)


GO

-- ----------------------------
-- Records of Statistics
-- ----------------------------
INSERT INTO [dbo].[Statistics] ([guid], [recordTime], [blog], [jotting], [article], [comment]) VALUES (N'1', N'2018-10-30 18:24:00.000', N'452325', N'6044656', N'631427', N'3143118')
GO
GO
INSERT INTO [dbo].[Statistics] ([guid], [recordTime], [blog], [jotting], [article], [comment]) VALUES (N'10', N'2018-11-06 10:14:00.000', N'453820', N'6064349', N'633380', N'3147951')
GO
GO
INSERT INTO [dbo].[Statistics] ([guid], [recordTime], [blog], [jotting], [article], [comment]) VALUES (N'2', N'2018-10-30 19:33:00.000', N'452301', N'6040552', N'631038', N'3143101')
GO
GO
INSERT INTO [dbo].[Statistics] ([guid], [recordTime], [blog], [jotting], [article], [comment]) VALUES (N'3', N'2018-10-30 19:54:00.000', N'452390', N'6044596', N'631426', N'3143343')
GO
GO
INSERT INTO [dbo].[Statistics] ([guid], [recordTime], [blog], [jotting], [article], [comment]) VALUES (N'4', N'2018-10-30 20:19:00.000', N'452325', N'6044656', N'631427', N'3143118')
GO
GO
INSERT INTO [dbo].[Statistics] ([guid], [recordTime], [blog], [jotting], [article], [comment]) VALUES (N'5', N'2018-10-31 09:12:00.000', N'452325', N'6044656', N'631427', N'3143118')
GO
GO
INSERT INTO [dbo].[Statistics] ([guid], [recordTime], [blog], [jotting], [article], [comment]) VALUES (N'6', N'2018-10-31 14:09:00.000', N'452600', N'6048879', N'631885', N'3143842')
GO
GO
INSERT INTO [dbo].[Statistics] ([guid], [recordTime], [blog], [jotting], [article], [comment]) VALUES (N'7', N'2018-11-01 09:49:00.000', N'452600', N'6048879', N'631885', N'3143842')
GO
GO
INSERT INTO [dbo].[Statistics] ([guid], [recordTime], [blog], [jotting], [article], [comment]) VALUES (N'73b3238c304742d3ad47d2b7658e8b93', N'2018-11-08 15:19:40.790', N'454322', N'6076429', N'634171', N'3150217')
GO
GO
INSERT INTO [dbo].[Statistics] ([guid], [recordTime], [blog], [jotting], [article], [comment]) VALUES (N'8', N'2018-11-01 16:44:00.000', N'452899', N'6053483', N'632282', N'3144886')
GO
GO
INSERT INTO [dbo].[Statistics] ([guid], [recordTime], [blog], [jotting], [article], [comment]) VALUES (N'9', N'2018-11-05 09:25:00.000', N'453593', N'6061382', N'633165', N'3147073')
GO
GO

-- ----------------------------
-- Table structure for sysdiagrams
-- ----------------------------
DROP TABLE [dbo].[sysdiagrams]
GO
CREATE TABLE [dbo].[sysdiagrams] (
[name] sysname NOT NULL ,
[principal_id] int NOT NULL ,
[diagram_id] int NOT NULL IDENTITY(1,1) ,
[version] int NULL ,
[definition] varbinary(MAX) NULL 
)


GO

-- ----------------------------
-- Records of sysdiagrams
-- ----------------------------
SET IDENTITY_INSERT [dbo].[sysdiagrams] ON
GO
SET IDENTITY_INSERT [dbo].[sysdiagrams] OFF
GO

-- ----------------------------
-- Indexes structure for table myRecord
-- ----------------------------

-- ----------------------------
-- Primary Key structure for table myRecord
-- ----------------------------
ALTER TABLE [dbo].[myRecord] ADD PRIMARY KEY ([guid])
GO

-- ----------------------------
-- Indexes structure for table Statistics
-- ----------------------------

-- ----------------------------
-- Primary Key structure for table Statistics
-- ----------------------------
ALTER TABLE [dbo].[Statistics] ADD PRIMARY KEY ([guid])
GO

-- ----------------------------
-- Indexes structure for table sysdiagrams
-- ----------------------------

-- ----------------------------
-- Primary Key structure for table sysdiagrams
-- ----------------------------
ALTER TABLE [dbo].[sysdiagrams] ADD PRIMARY KEY ([diagram_id])
GO

-- ----------------------------
-- Uniques structure for table sysdiagrams
-- ----------------------------
ALTER TABLE [dbo].[sysdiagrams] ADD UNIQUE ([principal_id] ASC, [name] ASC)
GO
